<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>xd-work</title>
    <style>
        .index {
            font-weight: bold;
            font-size: 25px;
        }
        .title {
            font-weight: bold;
            font-size: 25px;
        }
        li {
            list-style: none;
            padding: 5px;
        }
        .first-li {
            font-weight: bold;
            font-size: 20px;
        }
        .second-li {
            font-weight: bold;
        }
        .third-li {
            font-weight: normal;
        }
        .block {
            display: block;
        }
        table {
            width: 100%;
            margin-top: 10px;
            border-color: #E8E8E8;
        }
        .first-tr {
            text-align: center;
        }
        tr:hover {
            background: #ECF9FF;
        }
        td {
            font-weight: normal;
            padding: 5px;
            white-space: nowrap;
        }
        a {
            color: #000000;
            background-color: transparent;
            text-decoration: none;
            outline: none;
            cursor: pointer;
        }
        .module {
            color: green;
        }
        .module-list {
            color: #1890ff;
        }
    </style>
</head>
<body><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="module" id="module-DB_REVERSE_MYSQL-from" href="#module-DB_REVERSE_MYSQL-to">1 逆向解析_MYSQL</a>
<ul><li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-relation-from" href="#module-DB_REVERSE_MYSQL-relation-to">1 关联关系</a></li>
<li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-tableList-from" href="#module-DB_REVERSE_MYSQL-tableList-to">2 表清单</a></li>
<li class="second-li"><a class="module-list" id="module-DB_REVERSE_MYSQL-tableColumnList-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-to">3 表列清单</a>
<ul><li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-codes-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-codes-to">3.1 codes「codes 邀请码」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-demands-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-demands-to">3.2 demands「demands 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-docs-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-docs-to">3.3 docs「docs 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-project_demand-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-project_demand-to">3.4 project_demand「project_demand 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-projects-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-projects-to">3.5 projects「projects 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-team_user-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-team_user-to">3.6 team_user「team_user 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-teams-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-teams-to">3.7 teams「teams 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-templates-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-templates-to">3.8 templates「templates 」</a></li>
<li class="third-li"><a id="module-DB_REVERSE_MYSQL-tableColumnList-users-from" href="#module-DB_REVERSE_MYSQL-tableColumnList-users-to">3.9 users「users 用户表」</a></li>
</ul></li></ul></li></ul>
<hr><ul>

<li class="first-li"><a class="module" id="module-DB_REVERSE_MYSQL-to" href="#module-DB_REVERSE_MYSQL-from">1 逆向解析_MYSQL</a><ul>
<li class="second-li"><a class="module-list" class="block" id="module-DB_REVERSE_MYSQL-relation-to" href="#module-DB_REVERSE_MYSQL-relation-from">1.1 关联关系</a>
<img style="width: 98%;margin-top: 10px" src="" title="DB_REVERSE_MYSQL-关系图"/>
</li><hr>
<li><a class="module-list" id="module-DB_REVERSE_MYSQL-tableList-to" href="module-DB_REVERSE_MYSQL-tableList-from">1.2  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>codes 邀请码</td><td>codes</td><td></td></tr>
<tr><td>demands </td><td>demands</td><td></td></tr>
<tr><td>docs </td><td>docs</td><td></td></tr>
<tr><td>project_demand </td><td>project_demand</td><td></td></tr>
<tr><td>projects </td><td>projects</td><td></td></tr>
<tr><td>team_user </td><td>team_user</td><td></td></tr>
<tr><td>teams </td><td>teams</td><td></td></tr>
<tr><td>templates </td><td>templates</td><td></td></tr>
<tr><td>users 用户表</td><td>users</td><td></td></tr>
</table>
</li><hr>

<li><a class="module-list" id="module-DB_REVERSE_MYSQL-tableColumnList-to" href="module-DB_REVERSE_MYSQL-tableColumnList-from">1.3 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-codes-to" href="module-DB_REVERSE_MYSQL-tableColumnList-codes-from">1.3.1 codes「codes 邀请码」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>code</td><td>邀请码 6位整数</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>status</td><td>状态 1有效2无效</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-demands-to" href="module-DB_REVERSE_MYSQL-tableColumnList-demands-from">1.3.2 demands「demands 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>name</td><td>需求名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>project_id</td><td>项目id</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>intro</td><td>需求描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>status</td><td>状态 1进行中2已完成3已逾期4已取消</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>priority</td><td>优先级 1紧急重要2紧急不重要3重要不紧急4不紧急不重要</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>execute_by</td><td>执行人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deadline_at</td><td>截止时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-docs-to" href="module-DB_REVERSE_MYSQL-tableColumnList-docs-from">1.3.3 docs「docs 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>name</td><td>文档名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>intro</td><td>文档描述</td><td>TEXT</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-project_demand-to" href="module-DB_REVERSE_MYSQL-tableColumnList-project_demand-from">1.3.4 project_demand「project_demand 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>project_id</td><td>项目ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>demand_id</td><td>需求ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-projects-to" href="module-DB_REVERSE_MYSQL-tableColumnList-projects-from">1.3.5 projects「projects 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>name</td><td>项目名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>team_id</td><td>小组ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>avatar</td><td>头像</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>intro</td><td>项目描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>status</td><td>状态 1进行中2已完成3已逾期4已取消</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>template_id</td><td>模版ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>doc_id</td><td>文档ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deadline_at</td><td>截止时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-team_user-to" href="module-DB_REVERSE_MYSQL-tableColumnList-team_user-from">1.3.6 team_user「team_user 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>team_id</td><td>小组ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户ID</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-teams-to" href="module-DB_REVERSE_MYSQL-tableColumnList-teams-from">1.3.7 teams「teams 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>name</td><td>小组名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>avatar</td><td>头像</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>intro</td><td>小组描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>score</td><td>小组得分</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-templates-to" href="module-DB_REVERSE_MYSQL-tableColumnList-templates-from">1.3.8 templates「templates 」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>name</td><td>模版名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>avatar</td><td>头像</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>intro</td><td>模版描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>type</td><td>模版类型 1前端2后端</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-DB_REVERSE_MYSQL-tableColumnList-users-to" href="module-DB_REVERSE_MYSQL-tableColumnList-users-from">1.3.9 users「users 用户表」</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td>?</td><td>INT(10)</td><td>√</td><td></td></tr>
<tr><td>uid</td><td>UUID</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>user_name</td><td>账号</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>password</td><td>密码</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>user_type</td><td>类型 1超级管理员2管理员3普通用户</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>status</td><td>状态 active激活；inactive未激活；suspend被封禁；</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>nickname</td><td>名字</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>invite_code</td><td>邀请码</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>avatar</td><td>头像</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>intro</td><td>描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>skill</td><td>技能</td><td>VARCHAR(1024)</td><td></td><td></td></tr>
<tr><td>gender</td><td>性别 1男2女3未知</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>email</td><td>邮箱</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>mobile</td><td>手机</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>invite_num</td><td>邀请次数 超管无限次；管理员10次；普通用户3次；</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>source</td><td>来源 1注册2邀请码3微信</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>wechat</td><td>微信</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>revision</td><td>乐观锁</td><td>INT(10)</td><td></td><td></td></tr>
<tr><td>created_by</td><td>创建人</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td></tr>
<tr><td>deleted_at</td><td>删除时间</td><td>DATETIME</td><td></td><td></td></tr>
</table>
</li>

</ul></li></ul><hr></li></ul></body>
</html>